Tabela Event

Definicja tabeli Event

Name

Event

Code

Event

Comment

PL: Informacje o zdarzeniu(wskazanie placówki, lekarza)
EN: Episode(event) information (point at organization unit and doctor)


Lista kolumn tabeli Event

Name

Code

EventID

EventID

EventTypeID

EventTypeID

ReservationID

ReservationID

EmergEventQualificationID

EmergEventQualificationID

EventStatusID

EventStatusID

BedsTypeID

BedsTypeID

EpisodeID

EpisodeID

AdmissionModeID

AdmissionModeID

DayIntervalID

DayIntervalID

CostAccountID

CostAccountID

PersonID

PersonID

StartDT

StartDT

StopDT

StopDT

Comments

Comments

Bed

Bed

Charge

Charge

ConfirmDocumentNo

ConfirmDocumentNo

OldEpisodeID

OldEpisodeID

CancelReason

CancelReason

EventContractorID

EventContractorID

PriorityMarkerID

PriorityMarkerID

DischargingPersonID

DischargingPersonID


Kolumna EventID tabeli Event

Definicja kolumny EventID tabeli Event

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zdarzenia


Kolumna EventTypeID tabeli Event

Definicja kolumny EventTypeID tabeli Event

Name

EventTypeID

Code

EventTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ReservationID tabeli Event

Definicja kolumny ReservationID tabeli Event

Name

ReservationID

Code

ReservationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EmergEventQualificationID tabeli Event

Definicja kolumny EmergEventQualificationID tabeli Event

Name

EmergEventQualificationID

Code

EmergEventQualificationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventStatusID tabeli Event

Definicja kolumny EventStatusID tabeli Event

Name

EventStatusID

Code

EventStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BedsTypeID tabeli Event

Definicja kolumny BedsTypeID tabeli Event

Name

BedsTypeID

Code

BedsTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli Event

Definicja kolumny EpisodeID tabeli Event

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AdmissionModeID tabeli Event

Definicja kolumny AdmissionModeID tabeli Event

Name

AdmissionModeID

Code

AdmissionModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DayIntervalID tabeli Event

Definicja kolumny DayIntervalID tabeli Event

Name

DayIntervalID

Code

DayIntervalID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli Event

Definicja kolumny CostAccountID tabeli Event

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli Event

Definicja kolumny PersonID tabeli Event

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Event

Definicja kolumny StartDT tabeli Event

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Event

Definicja kolumny StopDT tabeli Event

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli Event

Definicja kolumny Comments tabeli Event

Name

Comments

Code

Comments

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna Bed tabeli Event

Definicja kolumny Bed tabeli Event

Name

Bed

Code

Bed

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna Charge tabeli Event

Definicja kolumny Charge tabeli Event

Name

Charge

Code

Charge

Data Type

NUMBER(6,2)

Mandatory

No

Comment

 


Kolumna ConfirmDocumentNo tabeli Event

Definicja kolumny ConfirmDocumentNo tabeli Event

Name

ConfirmDocumentNo

Code

ConfirmDocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna OldEpisodeID tabeli Event

Definicja kolumny OldEpisodeID tabeli Event

Name

OldEpisodeID

Code

OldEpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator epizodu w przypadku eventów anulowanych (czyli odpietych od Episodu)


Kolumna CancelReason tabeli Event

Definicja kolumny CancelReason tabeli Event

Name

CancelReason

Code

CancelReason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Powód anulowania przyjecia / przeniesienia pacjenta na oddzial


Kolumna EventContractorID tabeli Event

Definicja kolumny EventContractorID tabeli Event

Name

EventContractorID

Code

EventContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

platnik w pobycie


Kolumna PriorityMarkerID tabeli Event

Definicja kolumny PriorityMarkerID tabeli Event

Name

PriorityMarkerID

Code

PriorityMarkerID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID Markera, za pomoca którego bedzie mozna wydobyc np. odpowiedni kolor itp.


Kolumna DischargingPersonID tabeli Event

Definicja kolumny DischargingPersonID tabeli Event

Name

DischargingPersonID

Code

DischargingPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

lekarz decydujacy o przeniesieniu z oddzialu , badz wypisie.


Lista kluczy tabeli Event

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Event

Definicja klucza Identifier_1 tabeli Event

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment